package basic.bao;

import java.util.List;

import basic.a6.Employees;

public class Employeedao extends BaseDao<Employees> {
	public List<Employees> findAvg(){
		String sql="select * from employees a where a.salary>(select avg(e.salary) "
				+ "from employees e where a.department_id"
				+ "=e.department_id) order by a.department_id"; 
		return findBySql(sql);
	}
}
